package cn.sfa.entity.common;

import java.util.Date;

import cn.sfa.entity.base.BaseEntity;
/**
 * 
* 类名称：SaleAgentTrainCommonEntity   
* 类描述： Fast产品信息公共类
* 创建人：liuyi   
* 创建时间：2012-3-31 下午10:59:56   
* 修改人：liuyi   
* 修改时间：2012-2-31 下午10:59:56   
* 修改备注：   
* @version
 */
public class FastProductInfoCommonEntity extends BaseEntity {

	private String productid; //产品ID
	private String productcode;//产品编码
	private String productname;//产品名称
	private String abbrname;//产品简称
	private String producttype;//产品类型
	private String producttypename;//产品类型名称
	private String providerid;//供应商ID
	private String providername;//供应商名称
	private String salestatus;//产品销售状态
	private String salestatusname;//产品销售状态名称
	private Date salestartdate;//产品起售时间
	private Date saleenddate;//产品停售时间
	
	public String getProductid() {
		return productid;
	}
	public void setProductid(String productid) {
		this.productid = productid;
	}
	public String getProductcode() {
		return productcode;
	}
	public void setProductcode(String productcode) {
		this.productcode = productcode;
	}
	public String getProductname() {
		return productname;
	}
	public void setProductname(String productname) {
		this.productname = productname;
	}
	public String getAbbrname() {
		return abbrname;
	}
	public void setAbbrname(String abbrname) {
		this.abbrname = abbrname;
	}
	public String getProducttype() {
		return producttype;
	}
	public void setProducttype(String producttype) {
		this.producttype = producttype;
	}
	public String getProducttypename() {
		return producttypename;
	}
	public void setProducttypename(String producttypename) {
		this.producttypename = producttypename;
	}
	public String getProviderid() {
		return providerid;
	}
	public void setProviderid(String providerid) {
		this.providerid = providerid;
	}
	public String getProvidername() {
		return providername;
	}
	public void setProvidername(String providername) {
		this.providername = providername;
	}
	public String getSalestatus() {
		return salestatus;
	}
	public void setSalestatus(String salestatus) {
		this.salestatus = salestatus;
	}
	public String getSalestatusname() {
		return salestatusname;
	}
	public void setSalestatusname(String salestatusname) {
		this.salestatusname = salestatusname;
	}
	public Date getSalestartdate() {
		return salestartdate;
	}
	public void setSalestartdate(Date salestartdate) {
		this.salestartdate = salestartdate;
	}
	public Date getSaleenddate() {
		return saleenddate;
	}
	public void setSaleenddate(Date saleenddate) {
		this.saleenddate = saleenddate;
	}
	
	/*
	select 
	p.productid,
	p.createuserid,
	p.createdate,
	p.updateuserid,
	p.updatedate,
	p.productcode,
	p.productname,
	p.abbrname,
	p.producttype,
	scType.chnname producttypename,
	p.providerid,
	prd.providername,
	p.salestatus,
	scStatus.chnname salestatusname,
	p.salestartdate,
	p.saleenddate
	from product p
	left join syscode scType on scType.recordid = p.producttype
	left join provider prd on prd.providerid = p.providerid
	left join syscode scStatus on scStatus.recordid = p.salestatus
	where p.productid =''
	*/ 
}
